<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCrmWorkTimeTable extends Migration
{
    /**
     * Run the migrations.
     * 上班时间段设置表
     * @return void
     */
    public function up()
    {
        //
        Schema::create('crm_work_time', function (Blueprint $table) {
            $table->engine='MyISAM';
            $table->comment='上班时间段设置表';
            $table->tinyInteger('work_role_id')->default(0)->comment('角色');
            $table->tinyInteger('category')->default(0)->comment('上班类型: 1 早上,2 中午,3 晚上 ');
            $table->time('start_time')->default('0000:00:00')->comment('开始时间');
            $table->time('end_time')->default('0000:00:00')->comment('结束时间');

        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
        Schema::drop('crm_work_time');
    }
}
